//package main_com.mapper.old;
//
//
//import main_com.pojo.LookFriendBean;
//import org.apache.ibatis.annotations.*;
//
//import java.util.ArrayList;
//
//@Mapper
//public interface FriendMapper {
//
//    @Select("select * from friends where name = #{name} and username = #{userName}")
//    ArrayList<LookFriendBean> getFriendByNameAndUserName(String name, String userName);
//
//    @Select("select * from friends where username = #{userName}")
//    ArrayList<LookFriendBean> getFriendByUserName(String userName);
//
//    @Select("select * from friends where name = #{name}")
//    ArrayList<LookFriendBean> getFriendByName(String name);
//
//    @Select("select count(*) from friends where name = #{name}")
//    int findFriendByName(String name);
//
//    @Select("select count(*) from friends where name = #{name} and username = #{userName}")
//    int findFriendByNameAndUserName(String name, String userName);
//
//    @Update("update friends set phone=#{phone},email=#{email},workPlace=#{workPlace},place=#{place},QQ=#{QQ} where name=#{name} and userName=#{userName}")
//    void updateFriend(LookFriendBean friend);
//
//    @Insert("insert into friends values(#{userName}, #{name}, #{phone}, #{email}, #{workPlace}, #{place}, #{QQ})")
//    void addFriend(LookFriendBean friend);
//
//    @Delete("delete from friends where name=#{name} and userName=#{userName}")
//    void deleteFriendByNameAndUserName(String name, String userName);
//
//
//}
